Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 380286 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 144.7 MiB |
| Average record size in memory | 398.9 B |
Variable types
| CAT | 5 |
|---|---|
| NUM | 5 |
Reproduction
| Analysis started | 2020-03-19 05:03:58.835994 |
|---|---|
| Analysis finished | 2020-03-19 05:06:14.199396 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
StockCode has a high cardinality: 3630 distinct values | High cardinality |
Description has a high cardinality: 3830 distinct values | High cardinality |
InvoiceDate has a high cardinality: 16672 distinct values | High cardinality |
date has a high cardinality: 298 distinct values | High cardinality |
TotalCost is highly correlated with Quantity | High Correlation |
Quantity is highly correlated with TotalCost | High Correlation |
Quantity is highly skewed (γ1 = 534.8394849) | Skewed |
UnitPrice is highly skewed (γ1 = 209.4450002) | Skewed |
TotalCost is highly skewed (γ1 = 443.0241439) | Skewed |
InvoiceDate only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
InvoiceNo
Real number (ℝ≥0)
| Distinct count | 17858 |
|---|---|
| Unique (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 561358.8398600001 |
|---|---|
| Minimum | 537879 |
| Maximum | 581587 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 537879 |
|---|---|
| 5-th percentile | 540647 |
| Q1 | 550339 |
| median | 562539 |
| Q3 | 572295 |
| 95-th percentile | 579529.75 |
| Maximum | 581587 |
| Range | 43708 |
| Interquartile range (IQR) | 21956 |
Descriptive statistics
| Standard deviation | 12580.59317 |
|---|---|
| Coefficient of variation (CV) | 0.02241096474 |
| Kurtosis | -1.197917943 |
| Mean | 561358.8399 |
| Median Absolute Deviation (MAD) | 10938.36662 |
| Skewness | -0.1748974811 |
| Sum | 2.134769078e+11 |
| Variance | 158271324.5 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[537879. 537887.5 537889.5 537895.5 537900.5 ... 581566.5 581576. 581580.5 581584.5 581587. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 576339 | 542 | 0.1% | |
| 579196 | 533 | 0.1% | |
| 580727 | 529 | 0.1% | |
| 578270 | 442 | 0.1% | |
| 573576 | 435 | 0.1% | |
| 567656 | 421 | 0.1% | |
| 567183 | 392 | 0.1% | |
| 575607 | 377 | 0.1% | |
| 571441 | 364 | 0.1% | |
| 570488 | 353 | 0.1% | |
| Other values (17848) | 375898 | 98.8% |
| Value | Count | Frequency (%) | |
| 537879 | 8 | < 0.1% | |
| 537880 | 16 | < 0.1% | |
| 537881 | 12 | < 0.1% | |
| 537882 | 4 | < 0.1% | |
| 537883 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 581587 | 15 | < 0.1% | |
| 581586 | 4 | < 0.1% | |
| 581585 | 21 | < 0.1% | |
| 581584 | 2 | < 0.1% | |
| 581583 | 2 | < 0.1% |
| Distinct count | 3630 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 85123A | 1931 |
|---|---|
| 22423 | 1649 |
| 85099B | 1569 |
| 47566 | 1382 |
| 84879 | 1342 |
| Other values (3625) |
| Value | Count | Frequency (%) | |
| 85123A | 1931 | 0.5% | |
| 22423 | 1649 | 0.4% | |
| 85099B | 1569 | 0.4% | |
| 47566 | 1382 | 0.4% | |
| 84879 | 1342 | 0.4% | |
| 20725 | 1277 | 0.3% | |
| 22720 | 1152 | 0.3% | |
| 23203 | 1091 | 0.3% | |
| POST | 1073 | 0.3% | |
| 20727 | 1052 | 0.3% | |
| Other values (3620) | 366768 | 96.4% |
Length
| Max length | 12 |
|---|---|
| Mean length | 5.077039386 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 68.6% | |
| Decimal_Number | 10 | 28.6% | |
| Space_Separator | 1 | 2.9% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 68.6% | |
| Common | 11 | 31.4% |
| Value | Count | Frequency (%) | |
| ASCII | 35 | 100.0% |
| Distinct count | 3830 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| WHITE HANGING HEART T-LIGHT HOLDER | 1924 |
|---|---|
| REGENCY CAKESTAND 3 TIER | 1649 |
| JUMBO BAG RED RETROSPOT | 1569 |
| PARTY BUNTING | 1382 |
| ASSORTED COLOUR BIRD ORNAMENT | 1342 |
| Other values (3825) |
| Value | Count | Frequency (%) | |
| WHITE HANGING HEART T-LIGHT HOLDER | 1924 | 0.5% | |
| REGENCY CAKESTAND 3 TIER | 1649 | 0.4% | |
| JUMBO BAG RED RETROSPOT | 1569 | 0.4% | |
| PARTY BUNTING | 1382 | 0.4% | |
| ASSORTED COLOUR BIRD ORNAMENT | 1342 | 0.4% | |
| LUNCH BAG RED RETROSPOT | 1276 | 0.3% | |
| SET OF 3 CAKE TINS PANTRY DESIGN | 1152 | 0.3% | |
| POSTAGE | 1073 | 0.3% | |
| LUNCH BAG BLACK SKULL. | 1052 | 0.3% | |
| SPOTTY BUNTING | 1014 | 0.3% | |
| Other values (3820) | 366853 | 96.5% |
Length
| Max length | 35 |
|---|---|
| Mean length | 26.66501265 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 38.2% | |
| Lowercase_Letter | 20 | 29.4% | |
| Decimal_Number | 10 | 14.7% | |
| Other_Punctuation | 7 | 10.3% | |
| Dash_Punctuation | 1 | 1.5% | |
| Math_Symbol | 1 | 1.5% | |
| Open_Punctuation | 1 | 1.5% | |
| Close_Punctuation | 1 | 1.5% | |
| Space_Separator | 1 | 1.5% |
| Value | Count | Frequency (%) | |
| Latin | 46 | 67.6% | |
| Common | 22 | 32.4% |
| Value | Count | Frequency (%) | |
| ASCII | 68 | 100.0% |
| Distinct count | 347 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.498974456067277 |
|---|---|
| Minimum | 1 |
| Maximum | 323980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 24 |
| 95-th percentile | 96 |
| Maximum | 323980 |
| Range | 323979 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 553.8243856 |
|---|---|
| Coefficient of variation (CV) | 21.71947686 |
| Kurtosis | 308880.4755 |
| Mean | 25.49897446 |
| Median Absolute Deviation (MAD) | 28.48140828 |
| Skewness | 534.8394849 |
| Sum | 9696903 |
| Variance | 306721.4501 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.0000e+00 1.5000e+00 2.5000e+00 3.5000e+00 4.5000e+00 ... 2.5000e+03 4.0400e+03 6.2800e+03 1.0800e+04 3.2398e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 12 | 49457 | 13.0% | |
| 4 | 47416 | 12.5% | |
| 1 | 39286 | 10.3% | |
| 2 | 36381 | 9.6% | |
| 24 | 27207 | 7.2% | |
| 8 | 27189 | 7.1% | |
| 6 | 24959 | 6.6% | |
| 48 | 22080 | 5.8% | |
| 3 | 16639 | 4.4% | |
| 10 | 14901 | 3.9% | |
| Other values (337) | 74771 | 19.7% |
| Value | Count | Frequency (%) | |
| 1 | 39286 | 10.3% | |
| 2 | 36381 | 9.6% | |
| 3 | 16639 | 4.4% | |
| 4 | 47416 | 12.5% | |
| 5 | 4867 | 1.3% |
| Value | Count | Frequency (%) | |
| 323980 | 1 | < 0.1% | |
| 74215 | 1 | < 0.1% | |
| 50160 | 1 | < 0.1% | |
| 19200 | 1 | < 0.1% | |
| 12000 | 1 | < 0.1% |
| Distinct count | 16672 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 2011-11-14 15:27:00 | 542 |
|---|---|
| 2011-11-28 15:54:00 | 533 |
| 2011-12-05 17:17:00 | 529 |
| 2011-11-23 13:39:00 | 443 |
| 2011-10-31 14:09:00 | 435 |
| Other values (16667) |
| Value | Count | Frequency (%) | |
| 2011-11-14 15:27:00 | 542 | 0.1% | |
| 2011-11-28 15:54:00 | 533 | 0.1% | |
| 2011-12-05 17:17:00 | 529 | 0.1% | |
| 2011-11-23 13:39:00 | 443 | 0.1% | |
| 2011-10-31 14:09:00 | 435 | 0.1% | |
| 2011-09-21 14:40:00 | 421 | 0.1% | |
| 2011-11-10 12:37:00 | 377 | 0.1% | |
| 2011-10-17 13:31:00 | 364 | 0.1% | |
| 2011-10-10 17:12:00 | 353 | 0.1% | |
| 2011-10-24 17:07:00 | 352 | 0.1% | |
| Other values (16662) | 375937 | 98.9% |
Length
| Max length | 19 |
|---|---|
| Mean length | 19 |
| Min length | 19 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 76.9% | |
| Dash_Punctuation | 1 | 7.7% | |
| Other_Punctuation | 1 | 7.7% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 633 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.002069543448877 |
|---|---|
| Minimum | 0.0 |
| Maximum | 8142.75 |
| Zeros | 39 |
| Zeros (%) | < 0.1% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3696 |
| Q1 | 1.1 |
| median | 1.716 |
| Q3 | 3.3 |
| 95-th percentile | 8.5 |
| Maximum | 8142.75 |
| Range | 8142.75 |
| Interquartile range (IQR) | 2.2 |
Descriptive statistics
| Standard deviation | 21.50586539 |
|---|---|
| Coefficient of variation (CV) | 7.163679947 |
| Kurtosis | 62982.48651 |
| Mean | 3.002069543 |
| Median Absolute Deviation (MAD) | 2.30487974 |
| Skewness | 209.4450002 |
| Sum | 1141645.018 |
| Variance | 462.5022461 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-04 1.810000e-02 3.760000e-02 5.640000e-02 ... 2.940000e+02 2.966688e+02 8.259904e+02 2.638618e+03 8.142750e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1.25 | 28261 | 7.4% | |
| 1.65 | 24169 | 6.4% | |
| 2.95 | 18102 | 4.8% | |
| 0.85 | 17584 | 4.6% | |
| 1.1 | 15349 | 4.0% | |
| 0.42 | 14799 | 3.9% | |
| 4.95 | 11303 | 3.0% | |
| 1.452 | 11102 | 2.9% | |
| 3.75 | 10695 | 2.8% | |
| 2.1 | 10434 | 2.7% | |
| Other values (623) | 218488 | 57.5% |
| Value | Count | Frequency (%) | |
| 0 | 39 | < 0.1% | |
| 0.001 | 4 | < 0.1% | |
| 0.0352 | 27 | < 0.1% | |
| 0.04 | 39 | < 0.1% | |
| 0.0528 | 53 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8142.75 | 1 | < 0.1% | |
| 3661.7328 | 2 | < 0.1% | |
| 3475.4016 | 1 | < 0.1% | |
| 2777.236 | 1 | < 0.1% | |
| 2500 | 1 | < 0.1% |
CustomerID
Real number (ℝ≥0)
| Distinct count | 4275 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15277.57957432038 |
|---|---|
| Minimum | 12346.0 |
| Maximum | 18287.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 12346 |
|---|---|
| 5-th percentile | 12624 |
| Q1 | 13949 |
| median | 15132 |
| Q3 | 16779 |
| 95-th percentile | 17891 |
| Maximum | 18287 |
| Range | 5941 |
| Interquartile range (IQR) | 2830 |
Descriptive statistics
| Standard deviation | 1710.601133 |
|---|---|
| Coefficient of variation (CV) | 0.1119680722 |
| Kurtosis | -1.176653792 |
| Mean | 15277.57957 |
| Median Absolute Deviation (MAD) | 1475.561052 |
| Skewness | 0.03806843411 |
| Sum | 5809849626 |
| Variance | 2926156.236 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[12346. 12346.5 12347.5 12348.5 12349.5 ... 18271. 18272.5 18282.5 18285. 18287. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 17841 | 7537 | 2.0% | |
| 14911 | 5543 | 1.5% | |
| 14096 | 5111 | 1.3% | |
| 12748 | 4063 | 1.1% | |
| 14606 | 2557 | 0.7% | |
| 15311 | 2282 | 0.6% | |
| 14646 | 2080 | 0.5% | |
| 13089 | 1773 | 0.5% | |
| 13263 | 1667 | 0.4% | |
| 14298 | 1637 | 0.4% | |
| Other values (4265) | 346036 | 91.0% |
| Value | Count | Frequency (%) | |
| 12346 | 1 | < 0.1% | |
| 12347 | 151 | < 0.1% | |
| 12348 | 31 | < 0.1% | |
| 12349 | 73 | < 0.1% | |
| 12350 | 17 | < 0.1% |
| Value | Count | Frequency (%) | |
| 18287 | 70 | < 0.1% | |
| 18283 | 721 | 0.2% | |
| 18282 | 12 | < 0.1% | |
| 18281 | 7 | < 0.1% | |
| 18280 | 10 | < 0.1% |
Country
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| United Kingdom | |
|---|---|
| Germany | 8823 |
| France | 8149 |
| EIRE | 7096 |
| Spain | 2475 |
| Other values (31) | 16073 |
| Value | Count | Frequency (%) | |
| United Kingdom | 337670 | 88.8% | |
| Germany | 8823 | 2.3% | |
| France | 8149 | 2.1% | |
| EIRE | 7096 | 1.9% | |
| Spain | 2475 | 0.7% | |
| Netherlands | 2361 | 0.6% | |
| Belgium | 2019 | 0.5% | |
| Switzerland | 1836 | 0.5% | |
| Portugal | 1386 | 0.4% | |
| Australia | 1162 | 0.3% | |
| Other values (26) | 7309 | 1.9% |
Length
| Max length | 20 |
|---|---|
| Mean length | 13.18699084 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 22 | 55.0% | |
| Uppercase_Letter | 17 | 42.5% | |
| Space_Separator | 1 | 2.5% |
| Value | Count | Frequency (%) | |
| Latin | 39 | 97.5% | |
| Common | 1 | 2.5% |
| Value | Count | Frequency (%) | |
| ASCII | 40 | 100.0% |
| Distinct count | 298 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 2011-11-06 | 3340 |
|---|---|
| 2011-12-05 | 3335 |
| 2011-11-23 | 3216 |
| 2011-11-10 | 3104 |
| 2011-11-20 | 3003 |
| Other values (293) |
| Value | Count | Frequency (%) | |
| 2011-11-06 | 3340 | 0.9% | |
| 2011-12-05 | 3335 | 0.9% | |
| 2011-11-23 | 3216 | 0.8% | |
| 2011-11-10 | 3104 | 0.8% | |
| 2011-11-20 | 3003 | 0.8% | |
| 2011-11-17 | 2945 | 0.8% | |
| 2011-11-14 | 2854 | 0.8% | |
| 2011-10-30 | 2850 | 0.7% | |
| 2011-11-22 | 2758 | 0.7% | |
| 2011-11-28 | 2708 | 0.7% | |
| Other values (288) | 350173 | 92.1% |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Dash_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 2778 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.713856949769387 |
|---|---|
| Minimum | 0.0 |
| Maximum | 168469.6 |
| Zeros | 39 |
| Zeros (%) | < 0.1% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.25 |
| Q1 | 4.95 |
| median | 12.48 |
| Q3 | 19.8 |
| 95-th percentile | 67.6 |
| Maximum | 168469.6 |
| Range | 168469.6 |
| Interquartile range (IQR) | 14.85 |
Descriptive statistics
| Standard deviation | 315.7374474 |
|---|---|
| Coefficient of variation (CV) | 13.90065316 |
| Kurtosis | 223023.0172 |
| Mean | 22.71385695 |
| Median Absolute Deviation (MAD) | 21.06027898 |
| Skewness | 443.0241439 |
| Sum | 8637761.804 |
| Variance | 99690.13567 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-04 1.100000e-01 1.300000e-01 1.850000e-01 ... 2.126400e+03 3.300000e+03 4.956750e+03 7.643735e+03 1.684696e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 15 | 19465 | 5.1% | |
| 19.8 | 10812 | 2.8% | |
| 17.7 | 8821 | 2.3% | |
| 16.5 | 8399 | 2.2% | |
| 10.2 | 7722 | 2.0% | |
| 1.25 | 6263 | 1.6% | |
| 3.75 | 6115 | 1.6% | |
| 20.8 | 5494 | 1.4% | |
| 10.5 | 5414 | 1.4% | |
| 2.5 | 5298 | 1.4% | |
| Other values (2768) | 296483 | 78.0% |
| Value | Count | Frequency (%) | |
| 0 | 39 | < 0.1% | |
| 0.001 | 4 | < 0.1% | |
| 0.06 | 1 | < 0.1% | |
| 0.08 | 1 | < 0.1% | |
| 0.1 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 168469.6 | 1 | < 0.1% | |
| 77183.6 | 1 | < 0.1% | |
| 38970 | 1 | < 0.1% | |
| 8142.75 | 1 | < 0.1% | |
| 7144.72 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | date | TotalCost | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 537879 | 21524 | DOORMAT SPOTTY HOME SWEET HOME | 2 | 2010-12-09 08:34:00 | 7.95 | 14243.0 | United Kingdom | 2010-12-09 | 15.9 |
| 1 | 537879 | 22114 | HOT WATER BOTTLE TEA AND SYMPATHY | 12 | 2010-12-09 08:34:00 | 3.95 | 14243.0 | United Kingdom | 2010-12-09 | 47.4 |
| 2 | 537879 | 22694 | WICKER STAR | 6 | 2010-12-09 08:34:00 | 2.10 | 14243.0 | United Kingdom | 2010-12-09 | 12.6 |
| 3 | 537879 | 22835 | HOT WATER BOTTLE I AM SO POORLY | 8 | 2010-12-09 08:34:00 | 4.65 | 14243.0 | United Kingdom | 2010-12-09 | 37.2 |
| 4 | 537879 | 85048 | 15CM CHRISTMAS GLASS BALL 20 LIGHTS | 4 | 2010-12-09 08:34:00 | 7.95 | 14243.0 | United Kingdom | 2010-12-09 | 31.8 |
| 5 | 537879 | 85150 | LADIES & GENTLEMEN METAL SIGN | 6 | 2010-12-09 08:34:00 | 2.55 | 14243.0 | United Kingdom | 2010-12-09 | 15.3 |
| 6 | 537879 | 82494L | WOODEN FRAME ANTIQUE WHITE | 12 | 2010-12-09 08:34:00 | 2.95 | 14243.0 | United Kingdom | 2010-12-09 | 35.4 |
| 7 | 537879 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-12-09 08:34:00 | 2.95 | 14243.0 | United Kingdom | 2010-12-09 | 17.7 |
| 8 | 537880 | 85150 | LADIES & GENTLEMEN METAL SIGN | 12 | 2010-12-09 09:14:00 | 2.55 | 12963.0 | United Kingdom | 2010-12-09 | 30.6 |
| 9 | 537880 | 48187 | DOORMAT NEW ENGLAND | 2 | 2010-12-09 09:14:00 | 7.95 | 12963.0 | United Kingdom | 2010-12-09 | 15.9 |
Last rows
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | date | TotalCost | |
|---|---|---|---|---|---|---|---|---|---|---|
| 380276 | 581587 | 22726 | ALARM CLOCK BAKELIKE GREEN | 16 | 2011-12-09 12:50:00 | 3.300 | 12680.0 | France | 2011-12-09 | 15.00 |
| 380277 | 581587 | 22138 | BAKING SET 9 PIECE RETROSPOT | 12 | 2011-12-09 12:50:00 | 4.356 | 12680.0 | France | 2011-12-09 | 14.85 |
| 380278 | 581587 | 22629 | SPACEBOY LUNCH BOX | 48 | 2011-12-09 12:50:00 | 1.716 | 12680.0 | France | 2011-12-09 | 23.40 |
| 380279 | 581587 | 22613 | PACK OF 20 SPACEBOY NAPKINS | 48 | 2011-12-09 12:50:00 | 0.748 | 12680.0 | France | 2011-12-09 | 10.20 |
| 380280 | 581587 | 22556 | PLASTERS IN TIN CIRCUS PARADE | 48 | 2011-12-09 12:50:00 | 1.452 | 12680.0 | France | 2011-12-09 | 19.80 |
| 380281 | 581587 | 22555 | PLASTERS IN TIN STRONGMAN | 48 | 2011-12-09 12:50:00 | 1.452 | 12680.0 | France | 2011-12-09 | 19.80 |
| 380282 | 581587 | 22367 | CHILDRENS APRON SPACEBOY DESIGN | 32 | 2011-12-09 12:50:00 | 1.716 | 12680.0 | France | 2011-12-09 | 15.60 |
| 380283 | 581587 | 23255 | CHILDRENS CUTLERY CIRCUS PARADE | 16 | 2011-12-09 12:50:00 | 3.652 | 12680.0 | France | 2011-12-09 | 16.60 |
| 380284 | 581587 | 22631 | CIRCUS PARADE LUNCH BOX | 48 | 2011-12-09 12:50:00 | 1.716 | 12680.0 | France | 2011-12-09 | 23.40 |
| 380285 | 581587 | 23256 | CHILDRENS CUTLERY SPACEBOY | 16 | 2011-12-09 12:50:00 | 3.652 | 12680.0 | France | 2011-12-09 | 16.60 |